CREATE PROCEDURE [dbo].[BAEFieldDesignUpdate]
        @FieldDesignId AS int,
        @TableName AS varchar(30),
        @FieldName AS varchar(128),
        @FieldState AS int,
        @RegularExpression AS varchar(255),
        @RegularExpressionExample AS varchar(255),
        @MemberTypes AS varchar(255)
    AS
    UPDATE FieldDesign SET
    FieldState = @FieldState,
    RegularExpression = @RegularExpression,
    RegularExpressionExample = @RegularExpressionExample,
    MemberTypes = @MemberTypes
    WHERE FieldDesignId = @FieldDesignId AND TableName = @TableName AND
    FieldName = @FieldName

-------------------------------------------

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF

GO